Selection Styles for Cube Views

Using Selection Styles

You can bring an existing cube view into Excel or Spreadsheet and format using functionality that is included in Excel, to create highly formatted reporting. You can also modify it locally as well as in spreadsheet. You can use existing cube view formatting, add new styles to apply changes to rows, columns, or cells, or a combination of existing styles with new styles, and add conditional formatting.

Creating a Selection Style

1. Log in using the OneStream menu.

2. Click Cube Views > Cube View Connections.

3. Click the Add button.
   

4. Select the cube view, click the OK button, then the Closebutton. 
   

   

5. Select the cell, a group of cells, a column, or row to format.

   .

6. Right-click to open Format Cells or use the Home menu to choose formatting.
   

7. After formatting, click OneStream > Cube Views > Selection Styles.
   

8. Enter a Name and Range to apply to the current Selection, Entire Row, or Entire Column. Then click OK.
   

   

9. The formatting is applied to cube view.
   
   

10. Save the file to save the formatting to the cube view.

Using an Existing Style

1. Select the cell, a group of cells, a column, or row to format, then click Cube Views > Selection Styles.
   

2. Click Excel Styles to select a style. If a style is not selected the Default Cube View Format is used.
   

   

3. On the style palette, hover to view the styles.
   
   
   

4. Click the style to use and then Apply or OK.

5. Save the file to save the cube view formatting.

Adding a Selection Styles Shortcut

In Excel, right-click Selection Styles then click Add to Quick Access Toolbar. This adds a shortcut to your toolbar that launches the Selection Styles window.  

 

Reviewing Styles and Ranges

1. Click Cube Views > Manage Selection Styles.
   

2. Review your styles that are applied to the cube view.
   

3. Modify selected styles.
   

4. Enable or disable Active styles as needed and click OK.
   
   

5. Click Apply to preview the changes, or OK to apply the changes.
   

   

6. In Selection Styles, you will see styles that are no longer Active. Click Activate to enable them.
   

7. You can delete a style from the cube view but it will be available in the current workbook.
   

   

8. Save the file to save the cube view formatting.

Using Right-click Menu Options

You can manage selection styles by right-clicking in a cube view and selecting OneStream > Cube Views > Cube View Connections > Selection Styles > Manage Selection Styles.

Modifying and Duplicate Styles

1. In the Home menu, click Styles and right-click a style.
   

2. Click Modify or Duplicate and then Format.
   

3. Make any necessary changes and click OK.
   

4. Save the file.

Merging Styles

You can use styles created in other workbooks in Excel only.

1. Open a new workbook.

2. Add a cube view.

3. Click Home > Styles then the More arrow.
   
   

4. Click Merge Styles, select the style, and click OK.
   

The style is now available in the workbook.